// See the DataAccess setup code on the DataAccess class page.

// Executes a Select statement and retrieves the DbDataReader object.
private static void GetDataReader(DataAccess dataAccess)
{
  DbDataReader dbDataReader = null;

  string sql = "select * from TableName";
  try
  {
    // The "using" statement disposes the object when the scope is exited.
    using (dbDataReader = dataAccess.GetDataReader(sql))
    {
      while (dbDataReader.Read())
      {
        // Use the record here.
        for int index = 0; index < dbDataReader.FieldCount; index++)
        {
          string value = dbDataReader[index].ToString();
        }
      }
    }
  }
  finally
  {
    // The calling program must close the connection when done.
    dataAccess.CloseConnection();
  }
}